﻿CREATE TABLE [dbo].[Customer] (
    [CustomerNo]   VARCHAR (8)     NOT NULL,
    [CustomerName] VARCHAR (200)   NOT NULL,
    [ShortName]    VARCHAR (60)    NULL,
    [Contact]      VARCHAR (20)    NULL,
    [ContactTitle] VARCHAR (20)    NULL,
    [Tel]          VARCHAR (15)    NULL,
    [Mobile]       VARCHAR (15)    NULL,
    [Fax]          VARCHAR (15)    NULL,
    [Address]      VARCHAR (200)   NULL,
    [ZipCode]      VARCHAR (6)     NULL,
    [BankAccount]  VARCHAR (30)    NULL,
    [Bank]         VARCHAR (60)    NULL,
    [Credit]       NUMERIC (15, 2) NULL,
    [CreditPeriod] INT             NULL,
    [TaxAccount]   VARCHAR (30)    NULL,
    [Region]       VARCHAR (30)    NULL,
    [CustomerType] INT             NULL,
    [Remark]       VARCHAR (100)   NULL,
    [RecordID]     INT             IDENTITY (1, 1) NOT NULL
);

